MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Object Name = 4474

View and edit SQL

Suggested facets: Department, Title, Culture, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
37335 02.18.15 0 1 43424 Asian Art 7 Slab 4474   Burma 1304                             1902 1902 Jadeite 8170 H. 6 1/16 in. (15.4 cm); W. 6 in. (15.2 cm); L. 1 1/2 in. (3.8 cm) Gift of Heber R. Bishop, 1902                       Jade 174   Metropolitan Museum of Art, New York, NY 1
37336 02.18.16 0 1 43425 Asian Art 7 Slab 4474   Burma 1304                             1902 1902 Jadeite 8170 H. 8 5/8 in. (21.9 cm); W. 6 13/16 in. (17.3 cm); L. 9/16 in. (1.4 cm) Gift of Heber R. Bishop, 1902                       Jade 174   Metropolitan Museum of Art, New York, NY 1
200833 86.11.413 0 1 322030 Ancient Near Eastern Art 14 Slab 4474 Stone slab fragment with inscription from annals of Ashurbanipal Assyrian 5654 Neo-Assyrian                         ca. 668–627 B.C. -668 -627 Black stone 7565 5.12 x 5.68 x 3.35 in. (13 x 14.43 x 8.5 cm) Purchase, 1886           Mesopotamia 335 Nineveh (?) 10         Stone-Architectural-Inscribed 601   Metropolitan Museum of Art, New York, NY 1
311449 11.26.1 0 1 446193 Islamic Art 9 Slab 4474 Slab                             14th century 1300 1399 stone 18438 H. 7 in. (17.8 cm) W. 27 1/4 in. (69.2 cm) D. 1 11/16 in. (4.3 cm) Wt. [greater than >40 oz. (>1134 g)] Gift of Bashford Dean, 1911 Made in 1 Granada 1561     Spain 5             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
317072 66.81 0 1 451853 Islamic Art 9 Slab 4474 Slab                             first half 8th century 700 750 Ink on limestone 46842 Gr. H. 9 3/4 in. (24.8 cm) Th. 2 in. (5.1 cm) W. 5 3/4 in. (14.6 cm) Th. 2 in. (5.1 cm) Gift of H. Dunscombe Colt, 1966 Attributed to 20       Jordan 440             Stone 209   Metropolitan Museum of Art, New York, NY 1
319803 10.175.91 0 1 456180 Islamic Art 9 Slab 4474 Slab                             6th–7th century 500 699 Limestone 1737 H. 13 13/16 in. (35.1 cm) W. 7 7/16 in. (18.9 cm) D. 2 3/8 in. (6 cm) Rogers Fund, 1910 Found 34 Saqqara 1474     Egypt 104             Sculpture 12   Metropolitan Museum of Art, New York, NY 1
330396 25.120.131a-j 0 1 473459 The Cloisters 17 Slab 4474 Coping Slabs French 7                           12th–13th century 1100 1299 Stone 164 Overall (all approx. the same): 4 1/4 x 35 x 12 in. (10.8 x 88.9 x 30.5 cm) The Cloisters Collection, 1925 Made in 1     Languedoc 787 France 9             Sculpture-Architectural-Stone 852   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 122.113ms · Data license: CC0 · Data source: metmuseum/openaccess